Tabela Contract

Definicja tabeli Contract

Name

Contract

Code

Contract

Comment

m.in. kontrakt na benefit plany.
Inaczej Umowa.


Lista kolumn tabeli Contract

Name

Code

ContractID

ContractID

ContractTypeID

ContractTypeID

ContractKindID

ContractKindID

AddressID

AddressID

ContractNo

ContractNo

Description

Description

ClientName

ClientName

DebtorNo

DebtorNo

StartDT

StartDT

StopDT

StopDT

ActivationDT

ActivationDT

SignDT

SignDT

CancelDT

CancelDT

ExpireDT

ExpireDT

Comments

Comments

Notes

Notes

AlternativeContractNo

AlternativeContractNo

SummaryUnitsCount

SummaryUnitsCount

ImportDate

ImportDate

FileName

FileName

CurrentAnnexNo

CurrentAnnexNo

BankAccount

BankAccount

IsSecondPhaseGenByNfz

IsSecondPhaseGenByNfz

BankAccountOwner

BankAccountOwner

BankAccountOwnerAddressID

BankAccountOwnerAddressID

GenerationDate

GenerationDate

IsLumpSumContract

IsLumpSumContract


Kolumna ContractID tabeli Contract

Definicja kolumny ContractID tabeli Contract

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractTypeID tabeli Contract

Definicja kolumny ContractTypeID tabeli Contract

Name

ContractTypeID

Code

ContractTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractKindID tabeli Contract

Definicja kolumny ContractKindID tabeli Contract

Name

ContractKindID

Code

ContractKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AddressID tabeli Contract

Definicja kolumny AddressID tabeli Contract

Name

AddressID

Code

AddressID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractNo tabeli Contract

Definicja kolumny ContractNo tabeli Contract

Name

ContractNo

Code

ContractNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna Description tabeli Contract

Definicja kolumny Description tabeli Contract

Name

Description

Code

Description

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna ClientName tabeli Contract

Definicja kolumny ClientName tabeli Contract

Name

ClientName

Code

ClientName

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna DebtorNo tabeli Contract

Definicja kolumny DebtorNo tabeli Contract

Name

DebtorNo

Code

DebtorNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Contract

Definicja kolumny StartDT tabeli Contract

Name

StartDT

Code

StartDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna StopDT tabeli Contract

Definicja kolumny StopDT tabeli Contract

Name

StopDT

Code

StopDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna ActivationDT tabeli Contract

Definicja kolumny ActivationDT tabeli Contract

Name

ActivationDT

Code

ActivationDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna SignDT tabeli Contract

Definicja kolumny SignDT tabeli Contract

Name

SignDT

Code

SignDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna CancelDT tabeli Contract

Definicja kolumny CancelDT tabeli Contract

Name

CancelDT

Code

CancelDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ExpireDT tabeli Contract

Definicja kolumny ExpireDT tabeli Contract

Name

ExpireDT

Code

ExpireDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Comments tabeli Contract

Definicja kolumny Comments tabeli Contract

Name

Comments

Code

Comments

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Notes tabeli Contract

Definicja kolumny Notes tabeli Contract

Name

Notes

Code

Notes

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna AlternativeContractNo tabeli Contract

Definicja kolumny AlternativeContractNo tabeli Contract

Name

AlternativeContractNo

Code

AlternativeContractNo

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna SummaryUnitsCount tabeli Contract

Definicja kolumny SummaryUnitsCount tabeli Contract

Name

SummaryUnitsCount

Code

SummaryUnitsCount

Data Type

NUMBER(14,2)

Mandatory

No

Comment

 


Kolumna ImportDate tabeli Contract

Definicja kolumny ImportDate tabeli Contract

Name

ImportDate

Code

ImportDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna FileName tabeli Contract

Definicja kolumny FileName tabeli Contract

Name

FileName

Code

FileName

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna CurrentAnnexNo tabeli Contract

Definicja kolumny CurrentAnnexNo tabeli Contract

Name

CurrentAnnexNo

Code

CurrentAnnexNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna BankAccount tabeli Contract

Definicja kolumny BankAccount tabeli Contract

Name

BankAccount

Code

BankAccount

Data Type

VARCHAR2(26)

Mandatory

No

Comment

Numer rachunku bankowego


Kolumna IsSecondPhaseGenByNfz tabeli Contract

Definicja kolumny IsSecondPhaseGenByNfz tabeli Contract

Name

IsSecondPhaseGenByNfz

Code

IsSecondPhaseGenByNfz

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna BankAccountOwner tabeli Contract

Definicja kolumny BankAccountOwner tabeli Contract

Name

BankAccountOwner

Code

BankAccountOwner

Data Type

VARCHAR2(70)

Mandatory

No

Comment

Nazwa posiadacza konta


Kolumna BankAccountOwnerAddressID tabeli Contract

Definicja kolumny BankAccountOwnerAddressID tabeli Contract

Name

BankAccountOwnerAddressID

Code

BankAccountOwnerAddressID

Data Type

NUMBER(10)

Mandatory

No

Comment

Dane adresowe posiadacza konta


Kolumna GenerationDate tabeli Contract

Definicja kolumny GenerationDate tabeli Contract

Name

GenerationDate

Code

GenerationDate

Data Type

DATE

Mandatory

No

Comment

Data i czas generacji zaczytywanego komunikatu z umowa


Kolumna IsLumpSumContract tabeli Contract

Definicja kolumny IsLumpSumContract tabeli Contract

Name

IsLumpSumContract

Code

IsLumpSumContract

Data Type

NUMBER(5)

Mandatory

No

Comment

Flaga czy umowa ryczaltowa


Lista kluczy tabeli Contract

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Contract

Definicja klucza Identifier_1 tabeli Contract

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment